SELECT *, CASE WHEN `name` LIKE "long beach%" AND `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "long beach" AND `logo_file_name` IS NOT NULL THEN 10 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "long beach" AND `logo_file_name` IS NOT NULL THEN 2 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` = "long beach" AND `logo_file_name` IS NULL THEN 1 WHEN `sub_cat` IS NULL AND `cat` IS NULL AND `locality` IS NULL AND `logo_file_name` IS NULL THEN 0 END as `rank` FROM `wp_slides` WHERE st = "NY" AND (locality IN ("long beach") OR locality IS NULL) AND (cat IS NULL) AND name NOT IN ("home-top", "home-bot") AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND name NOT IN ("agent") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah
Get email when new and updated listings match this saved search.
Get email when newly sold listings match this saved search.
Save Search
Delete Shape
Click on these drawing tools to draw shapes to contain listings. You can save these shapes as a Saved Search.
$3,290,000668-670 W Broadway Unit 10Long Beach NY 11561View Listing
$2,850,000557 W Bay DrLong Beach NY 11561View Listing
$2,399,000209 Edwards BlvdLong Beach NY 11561View Listing
$2,350,875909 W Park AveLong Beach NY 11561View Listing
$1,999,00093 Dalton StLong Beach NY 11561View Listing
$1,799,99966 Virginia AveLong Beach NY 11561View Listing
$1,799,00036 Illinois AveLong Beach NY 11561View Listing
$1,799,000671 E Walnut StLong Beach NY 11561View Listing
$1,750,00020 Heron StLong Beach NY 11561View Listing
$1,649,872345 E Beech StLong Beach NY 11561View Listing
$1,550,000460 E Market StLong Beach NY 11561View Listing
$1,499,99956 W Beech StLong Beach NY 11561View Listing
$1,300,000657 Laurelton BlvdLong Beach NY 11561View Listing
$1,300,000764 W Park AveLong Beach NY 11561View Listing
$1,299,999118 Magnolia BlvdLong Beach NY 11561View Listing
$1,295,00086 Tennessee AveLong Beach NY 11561View Listing
$1,250,00076 New Hampshire StLong Beach NY 11561View Listing
$1,249,000420 OceanfrontLong Beach NY 11561View Listing
$1,225,000444 W Fulton StLong Beach NY 11561View Listing
$1,200,000110 W Beech StLong Beach NY 11561View Listing
$1,100,000465 W Market StLong Beach NY 11561View Listing
$1,050,00066 Delaware AveLong Beach NY 11561View Listing
$950,000144 Atlantic AveLong Beach NY 11561View Listing
$949,999207 Lindell BlvdLong Beach NY 11561View Listing
The data relating to real estate for sale on this site comes from ListHub. All properties are subject to prior sale, changes, or withdrawal. This site was last updated May-09-2024 9:25:09 am.
SELECT *, "0" as `rank` FROM `wp_slides` WHERE st = "NY" AND (cat = "lenders" OR cat IS NULL) AND (slide_file_name IS NOT NULL AND slide_file_name != "") AND (slide_location IS NULL OR slide_location = "") AND active = 1 ORDER BY `rank` DESC LIMIT 12
[0] matching rows / [0.00 msec]
Blog ID 55
Blah